package com.bkgy.controller.planking.dao;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.bkgy.commom.model.Temp;
import com.bkgy.controller.planking.entity.ExcObj;
import com.bkgy.controller.planking.entity.TbProfit1870Par;
import com.bkgy.controller.planking.entity.TbProfit1870Step1;
import com.bkgy.controller.planking.entity.dto.PlanKingTwoHourBase;
import org.apache.ibatis.annotations.Mapper;

import java.math.BigDecimal;
import java.util.Date;
import java.util.List;

@Mapper
public interface PlanKing1870Dao extends BaseMapper<TbProfit1870Par> {
    /**
     * 抽取宝信数据
     */
    public List<TbProfit1870Par> loadBaseDate(String startDate, String endDate);

    public List<PlanKingTwoHourBase> get1870twoHour(String startTime, String endTime);

    /**
     * 镀锌生产效益分析
     */
    public List<TbProfit1870Step1> loadStep1(Date startTime, Date endTime);

    /**
     * 上月压缩空气、清洗段水量、氢气用量
     */
    public ExcObj lastTotal(String startTime, String endTime);

    /**
     * 上月出口重量和
     */
    public BigDecimal lastMonthOutput(String startTime, String endTime);
    /**
     * 上月压缩空气不等于0时，出口重量和
     */
    public BigDecimal lastMonthOutputPressAir(String startTime, String endTime);
    public BigDecimal lastMonthOutputSteam(String startTime, String endTime);
    public BigDecimal lastMonthOutputSalt(String startTime, String endTime);
    public BigDecimal lastMonthOutputFine(String startTime, String endTime);
    public BigDecimal lastMonthOutputRough(String startTime, String endTime);
    public BigDecimal lastMonthOutputHy(String startTime, String endTime);
    public BigDecimal lastMonthOutputWater(String startTime, String endTime);
    public List<Temp> lastMonthOutputGas(String startTime, String endTime);

    /**
     * 查询吨钢收益
     */
    public List<Temp> loadTonBenifit();
}
